package com.tlxch.mapper;

import com.github.pagehelper.Page;
import com.tlxch.dto.StuAvgdto;
import com.tlxch.dto.TScGradedto;
import com.tlxch.pojo.SStudent;
import com.tlxch.pojo.ScGrades;
import com.tlxch.vo.Gradesvo;
import com.tlxch.vo.StuAvgvo;
import com.tlxch.vo.TScGradevo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ScGradesMapper {
    int deleteByPrimaryKey(Integer scgId);

    int insert(ScGrades record);

    int insertSelective(ScGrades record);

    ScGrades selectByPrimaryKey(Integer scgId);

    int updateByPrimaryKeySelective(ScGrades record);

    int updateByPrimaryKey(ScGrades record);

    void insertlist(List<ScGrades> scGrades);

    void upStuGradeBystuid(ScGrades scGrades);

    Page<TScGradevo> pageQuery(TScGradedto tScGradedto);

    StuAvgvo getStuAvg(StuAvgdto stuAvgdto);

    Gradesvo getstuGradeByciAndsid(String sid, String cid);
}